rmrs=# \d foo
                     
            Column             |            Type             |   Modifiers   
-------------------------------+-----------------------------+---------------
 foo_id                        | numeric(22,0)               | not null
 institution_id                | numeric(22,0)               | not null
 patient_id                    | numeric(22,0)               | not null
 top_parent_service_code       | character varying(40)       | not null
 top_parent_service_sys_id     | numeric(22,0)               | not null
 physiologic_time              | timestamp without time zone | not null
 top_parent_filler_order_id    | numeric(22,0)               | 
 dewey_decimal_tree_sort_order | character varying(100)      | not null
 sister_sequence_number        | numeric(22,0)               | 
 service_code                  | character varying(40)       | not null
 service_sys_id                | numeric(22,0)               | not null
 filler_order_id               | numeric(22,0)               | 
 immediate_variable_id         | numeric(22,0)               | 
 data_arrival_time             | timestamp without time zone | default now()
 specimen_id                   | numeric(22,0)               | 
 value_type                    | character varying(40)       | 
 value_text_for_display        | character varying(1010)     | 
 value_modifier_text           | character varying(1000)     | 
 value_if_type_is_coded_code   | character varying(40)       | 
 value_if_type_is_coded_sys_id | numeric(22,0)               | 
 value_if_type_is_numeric      | double precision            | 
 value_if_type_is_provider_id  | numeric(22,0)               | 
 value_if_type_is_location_id  | numeric(22,0)               | 
 value_if_type_is_time         | timestamp without time zone | 
 status_code                   | character varying(40)       | 
 clinical_status_code          | character varying(40)       | 
 interpretation_code           | character varying(40)       | 
 off_scale_exception_code      | character varying(40)       | 
 delta_check_code              | character varying(40)       | 
 producer_application_id       | numeric(22,0)               | 
 producer_location_id          | numeric(22,0)               | 
 origination_code              | character varying(40)       | 
 delivering_message_id         | numeric(22,0)               | 
 deliv_sub_id                  | character varying(40)       | 
 deliv_value                   | character varying(100)      | 
 deliv_value_text              | character varying(1000)     | 
 deliv_value_code_system       | character varying(100)      | 
 value_quantitative_form       | character varying(40)       | 
 deliv_service_code            | character varying(40)       | 
 deliv_service_code_text       | character varying(100)      | 
 deliv_service_code_system     | character varying(40)       | 
 deliv_unit_code               | character varying(40)       | 
 deliv_unit_text               | character varying(100)      | 
 deliv_unit_code_system        | character varying(40)       | 
 deliv_normal_range            | character varying(100)      | 
 normal_range_text             | character varying(100)      | 
 value_modifier_text_type_code | character varying(40)       |